﻿CREATE TABLE [dbo].[TipSpor] (
    [IDTipSpor]               INT             IDENTITY (1, 1) NOT NULL,
    [Nume]                    VARCHAR (15)    NULL,
    [Descriere]               VARCHAR (100)   NULL,
    [Valoare]                 DECIMAL (18, 2) NOT NULL,
    [Format]                  CHAR (1)        NULL,
    [Utilizat]                INT             NULL,
    [Ordonare]                INT             NULL,
    [IntraIn]                 VARCHAR (2)     NULL,
    [ConcediuOdihna]          BIT             NOT NULL,
    [ConcediuBoala]           BIT             NOT NULL,
    [Permanent]               BIT             NOT NULL,
    [Activ]                   BIT             NOT NULL,
    [DataDefinire]            DATETIME        NOT NULL,
    [IdOpContabila]           INT             NOT NULL,
    [ConcediuOreSuplimentare] BIT             NOT NULL,
    [BazaCalculSpor]          VARCHAR (2)     NULL,
    [InclusCAS]               BIT             DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_TipSpor] PRIMARY KEY CLUSTERED ([IDTipSpor] ASC)
);

